Overview

Dataset statistics

Number of variables	35
Number of observations	88003
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	23.5 MiB
Average record size in memory	280.0 B

Variable types

Numeric	13
Text	10
Categorical	9
DateTime	3

Alerts

`address_id` is highly overall correlated with `customer_id` and 1 other fields	High correlation
`amount` is highly overall correlated with `rental_rate`	High correlation
`customer_id` is highly overall correlated with `address_id` and 1 other fields	High correlation
`film_id` is highly overall correlated with `inventory_id`	High correlation
`inventory_id` is highly overall correlated with `film_id`	High correlation
`payment_id` is highly overall correlated with `address_id` and 1 other fields	High correlation
`rental_rate` is highly overall correlated with `amount`	High correlation
`staff_fn` is highly overall correlated with `staff_id` and 2 other fields	High correlation
`staff_id` is highly overall correlated with `staff_fn` and 2 other fields	High correlation
`staff_ln` is highly overall correlated with `staff_fn` and 2 other fields	High correlation
`store_id` is highly overall correlated with `staff_fn` and 2 other fields	High correlation
`active` is highly imbalanced (82.7%)	Imbalance

Reproduction

Analysis started	2026-01-26 07:06:05.411937
Analysis finished	2026-01-26 07:06:14.910463
Duration	9.5 seconds
Software version	ydata-profiling vv4.18.1
Download configuration	config.json

film_id
Real number (ℝ)

High correlation

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	502.01051

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	48
Q1	255
median	496
Q3	752
95-th percentile	952
Maximum	1000
Range	999
Interquartile range (IQR)	497

Descriptive statistics

Standard deviation	288.36419
Coefficient of variation (CV)	0.57441863
Kurtosis	-1.1874154
Mean	502.01051
Median Absolute Deviation (MAD)	247
Skewness	-0.010096326
Sum	44178431
Variance	83153.907
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
489	288	0.3%
892	276	0.3%
880	275	0.3%
249	273	0.3%
649	264	0.3%
301	261	0.3%
764	252	0.3%
369	248	0.3%
418	248	0.3%
966	240	0.3%
Other values (945)	85378	97.0%

Value	Count	Frequency (%)
1	230	0.3%
2	28	< 0.1%
3	60	0.1%
4	115	0.1%
5	60	0.1%
6	147	0.2%
7	75	0.1%
8	72	0.1%
9	108	0.1%
10	184	0.2%

Value	Count	Frequency (%)
1000	93	0.1%
999	85	0.1%
998	54	0.1%
997	30	< 0.1%
996	35	< 0.1%
995	23	< 0.1%
994	78	0.1%
993	180	0.2%
992	56	0.1%
991	64	0.1%

title
Text

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	27
Median length	22
Mean length	14.314387
Min length	8

Characters and Unicode

Total characters	1259709
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PATIENT SISTER
2nd row	PATIENT SISTER
3rd row	PATIENT SISTER
4th row	PATIENT SISTER
5th row	TALENTED HOMICIDE

Value	Count	Frequency (%)
heartbreakers	659	0.4%
boondock	655	0.4%
armageddon	647	0.4%
hellfighters	642	0.4%
apollo	625	0.4%
polish	597	0.3%
shakespeare	576	0.3%
desire	568	0.3%
instinct	558	0.3%
love	548	0.3%
Other values (974)	169931	96.5%

Most occurring characters

Value	Count	Frequency (%)
E	124786	9.9%
A	106224	8.4%
R	91956	7.3%
O	88848	7.1%
	88003	7.0%
N	83362	6.6%
I	83028	6.6%
S	78689	6.2%
T	72889	5.8%
L	60404	4.8%
Other values (17)	381520	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1259709	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	124786	9.9%
A	106224	8.4%
R	91956	7.3%
O	88848	7.1%
	88003	7.0%
N	83362	6.6%
I	83028	6.6%
S	78689	6.2%
T	72889	5.8%
L	60404	4.8%
Other values (17)	381520	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1259709	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	124786	9.9%
A	106224	8.4%
R	91956	7.3%
O	88848	7.1%
	88003	7.0%
N	83362	6.6%
I	83028	6.6%
S	78689	6.2%
T	72889	5.8%
L	60404	4.8%
Other values (17)	381520	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1259709	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	124786	9.9%
A	106224	8.4%
R	91956	7.3%
O	88848	7.1%
	88003	7.0%
N	83362	6.6%
I	83028	6.6%
S	78689	6.2%
T	72889	5.8%
L	60404	4.8%
Other values (17)	381520	30.3%

description
Text

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	130
Median length	115
Mean length	94.30574
Min length	70

Characters and Unicode

Total characters	8299188
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia
2nd row	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia
3rd row	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia
4th row	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia
5th row	A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat

Value	Count	Frequency (%)
a	388644	24.0%
of	91053	5.6%
and	88003	5.4%
who	88003	5.4%
must	88003	5.4%
in	88003	5.4%
the	16917	1.0%
mad	15834	1.0%
shark	10686	0.7%
boat	10387	0.6%
Other values (139)	731780	45.2%

Most occurring characters

Value	Count	Frequency (%)
	1529310	18.4%
a	727487	8.8%
n	572021	6.9%
o	508454	6.1%
e	496140	6.0%
t	473395	5.7%
i	421059	5.1%
r	339854	4.1%
s	298869	3.6%
A	286081	3.4%
Other values (42)	2646518	31.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8299188	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1529310	18.4%
a	727487	8.8%
n	572021	6.9%
o	508454	6.1%
e	496140	6.0%
t	473395	5.7%
i	421059	5.1%
r	339854	4.1%
s	298869	3.6%
A	286081	3.4%
Other values (42)	2646518	31.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8299188	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1529310	18.4%
a	727487	8.8%
n	572021	6.9%
o	508454	6.1%
e	496140	6.0%
t	473395	5.7%
i	421059	5.1%
r	339854	4.1%
s	298869	3.6%
A	286081	3.4%
Other values (42)	2646518	31.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8299188	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1529310	18.4%
a	727487	8.8%
n	572021	6.9%
o	508454	6.1%
e	496140	6.0%
t	473395	5.7%
i	421059	5.1%
r	339854	4.1%
s	298869	3.6%
A	286081	3.4%
Other values (42)	2646518	31.9%

rental_duration
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

6	19279
4	18643
3	18215
5	17551
7	14315

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	88003
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	7
2nd row	7
3rd row	7
4th row	7
5th row	6

Common Values

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18215	20.7%
5	17551	19.9%
7	14315	16.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18215	20.7%
5	17551	19.9%
7	14315	16.3%

Most occurring characters

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18215	20.7%
5	17551	19.9%
7	14315	16.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18215	20.7%
5	17551	19.9%
7	14315	16.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18215	20.7%
5	17551	19.9%
7	14315	16.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
6	19279	21.9%
4	18643	21.2%
3	18215	20.7%
5	17551	19.9%
7	14315	16.3%

rental_rate
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

0.99	31137
2.99	28959
4.99	27907

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	352012
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.99
2nd row	0.99
3rd row	0.99
4th row	0.99
5th row	0.99

Common Values

Value	Count	Frequency (%)
0.99	31137	35.4%
2.99	28959	32.9%
4.99	27907	31.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.99	31137	35.4%
2.99	28959	32.9%
4.99	27907	31.7%

Most occurring characters

Value	Count	Frequency (%)
9	176006	50.0%
.	88003	25.0%
0	31137	8.8%
2	28959	8.2%
4	27907	7.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	352012	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	176006	50.0%
.	88003	25.0%
0	31137	8.8%
2	28959	8.2%
4	27907	7.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	352012	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	176006	50.0%
.	88003	25.0%
0	31137	8.8%
2	28959	8.2%
4	27907	7.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	352012	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	176006	50.0%
.	88003	25.0%
0	31137	8.8%
2	28959	8.2%
4	27907	7.9%

length
Real number (ℝ)

Distinct	140
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.10804

Minimum	46
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	46
5-th percentile	52
Q1	80
median	114
Q3	150
95-th percentile	178
Maximum	185
Range	139
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	40.497718
Coefficient of variation (CV)	0.35182354
Kurtosis	-1.1972212
Mean	115.10804
Median Absolute Deviation (MAD)	35
Skewness	0.027207201
Sum	10129853
Variance	1640.0652
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85	1495	1.7%
112	1358	1.5%
178	1355	1.5%
84	1178	1.3%
80	1072	1.2%
63	1070	1.2%
75	1056	1.2%
92	1041	1.2%
179	1019	1.2%
161	1008	1.1%
Other values (130)	76351	86.8%

Value	Count	Frequency (%)
46	585	0.7%
47	732	0.8%
48	832	0.9%
49	369	0.4%
50	563	0.6%
51	647	0.7%
52	704	0.8%
53	759	0.9%
54	524	0.6%
55	336	0.4%

Value	Count	Frequency (%)
185	936	1.1%
184	393	0.4%
183	417	0.5%
182	252	0.3%
181	837	1.0%
180	376	0.4%
179	1019	1.2%
178	1355	1.5%
177	660	0.7%
176	893	1.0%

replacement_cost
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.190914

Minimum	9.99
Maximum	29.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	9.99
5-th percentile	10.99
Q1	14.99
median	20.99
Q3	24.99
95-th percentile	29.99
Maximum	29.99
Range	20
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.0875717
Coefficient of variation (CV)	0.30150056
Kurtosis	-1.2236016
Mean	20.190914
Median Absolute Deviation (MAD)	5
Skewness	-0.035295321
Sum	1776861
Variance	37.058529
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
22.99	5626	6.4%
27.99	5215	5.9%
12.99	5024	5.7%
21.99	4902	5.6%
14.99	4893	5.6%
29.99	4686	5.3%
20.99	4672	5.3%
26.99	4264	4.8%
13.99	4213	4.8%
11.99	4167	4.7%
Other values (11)	40341	45.8%

Value	Count	Frequency (%)
9.99	3924	4.5%
10.99	3526	4.0%
11.99	4167	4.7%
12.99	5024	5.7%
13.99	4213	4.8%
14.99	4893	5.6%
15.99	3141	3.6%
16.99	3593	4.1%
17.99	3755	4.3%
18.99	3744	4.3%

Value	Count	Frequency (%)
29.99	4686	5.3%
28.99	4080	4.6%
27.99	5215	5.9%
26.99	4264	4.8%
25.99	3727	4.2%
24.99	3431	3.9%
23.99	3870	4.4%
22.99	5626	6.4%
21.99	4902	5.6%
20.99	4672	5.3%

rating
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

PG-13	19065
PG	18635
NC-17	17630
R	17210
G	15463

Length

Max length	5
Median length	2
Mean length	2.8796518
Min length	1

Characters and Unicode

Total characters	253418
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NC-17
2nd row	NC-17
3rd row	NC-17
4th row	NC-17
5th row	PG

Common Values

Value	Count	Frequency (%)
PG-13	19065	21.7%
PG	18635	21.2%
NC-17	17630	20.0%
R	17210	19.6%
G	15463	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pg-13	19065	21.7%
pg	18635	21.2%
nc-17	17630	20.0%
r	17210	19.6%
g	15463	17.6%

Most occurring characters

Value	Count	Frequency (%)
G	53163	21.0%
P	37700	14.9%
-	36695	14.5%
1	36695	14.5%
3	19065	7.5%
N	17630	7.0%
C	17630	7.0%
7	17630	7.0%
R	17210	6.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	253418	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	53163	21.0%
P	37700	14.9%
-	36695	14.5%
1	36695	14.5%
3	19065	7.5%
N	17630	7.0%
C	17630	7.0%
7	17630	7.0%
R	17210	6.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	253418	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	53163	21.0%
P	37700	14.9%
-	36695	14.5%
1	36695	14.5%
3	19065	7.5%
N	17630	7.0%
C	17630	7.0%
7	17630	7.0%
R	17210	6.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	253418	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	53163	21.0%
P	37700	14.9%
-	36695	14.5%
1	36695	14.5%
3	19065	7.5%
N	17630	7.0%
C	17630	7.0%
7	17630	7.0%
R	17210	6.8%

actor_id
Real number (ℝ)

Distinct	200
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.96492

Minimum	1
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	52
median	102
Q3	149
95-th percentile	191
Maximum	200
Range	199
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	56.908857
Coefficient of variation (CV)	0.56364979
Kurtosis	-1.1749861
Mean	100.96492
Median Absolute Deviation (MAD)	48
Skewness	0.0019690918
Sum	8885216
Variance	3238.618
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107	753	0.9%
181	678	0.8%
198	675	0.8%
144	654	0.7%
102	640	0.7%
60	612	0.7%
150	611	0.7%
37	605	0.7%
23	604	0.7%
90	599	0.7%
Other values (190)	81572	92.7%

Value	Count	Frequency (%)
1	305	0.3%
2	387	0.4%
3	311	0.4%
4	274	0.3%
5	496	0.6%
6	279	0.3%
7	479	0.5%
8	317	0.4%
9	381	0.4%
10	362	0.4%

Value	Count	Frequency (%)
200	350	0.4%
199	255	0.3%
198	675	0.8%
197	553	0.6%
196	450	0.5%
195	450	0.5%
194	380	0.4%
193	449	0.5%
192	458	0.5%
191	523	0.6%

actor_fn
Text

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	11
Median length	8
Mean length	5.3009897
Min length	2

Characters and Unicode

Total characters	466503
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SEAN
2nd row	MILLA
3rd row	VAL
4th row	LUCILLE
5th row	JADA

Value	Count	Frequency (%)
penelope	1661	1.9%
kenneth	1643	1.9%
jayne	1565	1.8%
matthew	1518	1.7%
julia	1435	1.6%
groucho	1350	1.5%
morgan	1340	1.5%
ed	1311	1.5%
burt	1309	1.5%
christian	1286	1.5%
Other values (118)	73585	83.6%

Most occurring characters

Value	Count	Frequency (%)
E	65227	14.0%
A	52745	11.3%
R	41096	8.8%
N	40755	8.7%
L	29594	6.3%
I	29427	6.3%
O	18598	4.0%
S	18575	4.0%
T	18157	3.9%
M	17209	3.7%
Other values (14)	135120	29.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	466503	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	65227	14.0%
A	52745	11.3%
R	41096	8.8%
N	40755	8.7%
L	29594	6.3%
I	29427	6.3%
O	18598	4.0%
S	18575	4.0%
T	18157	3.9%
M	17209	3.7%
Other values (14)	135120	29.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	466503	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	65227	14.0%
A	52745	11.3%
R	41096	8.8%
N	40755	8.7%
L	29594	6.3%
I	29427	6.3%
O	18598	4.0%
S	18575	4.0%
T	18157	3.9%
M	17209	3.7%
Other values (14)	135120	29.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	466503	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	65227	14.0%
A	52745	11.3%
R	41096	8.8%
N	40755	8.7%
L	29594	6.3%
I	29427	6.3%
O	18598	4.0%
S	18575	4.0%
T	18157	3.9%
M	17209	3.7%
Other values (14)	135120	29.0%

actor_ln
Text

Distinct	121
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	12
Median length	9
Mean length	6.2453439
Min length	3

Characters and Unicode

Total characters	549609
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GUINESS
2nd row	KEITEL
3rd row	BOLGER
4th row	TRACY
5th row	RYDER

Value	Count	Frequency (%)
kilmer	2145	2.4%
nolte	2119	2.4%
temple	1788	2.0%
degeneres	1611	1.8%
keitel	1587	1.8%
berry	1480	1.7%
torn	1478	1.7%
hoffman	1455	1.7%
guiness	1426	1.6%
garland	1394	1.6%
Other values (111)	71520	81.3%

Most occurring characters

Value	Count	Frequency (%)
E	68637	12.5%
N	44882	8.2%
R	41122	7.5%
A	39731	7.2%
O	39696	7.2%
L	39456	7.2%
I	33956	6.2%
S	32309	5.9%
T	23679	4.3%
D	21504	3.9%
Other values (17)	164637	30.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	549609	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	68637	12.5%
N	44882	8.2%
R	41122	7.5%
A	39731	7.2%
O	39696	7.2%
L	39456	7.2%
I	33956	6.2%
S	32309	5.9%
T	23679	4.3%
D	21504	3.9%
Other values (17)	164637	30.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	549609	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	68637	12.5%
N	44882	8.2%
R	41122	7.5%
A	39731	7.2%
O	39696	7.2%
L	39456	7.2%
I	33956	6.2%
S	32309	5.9%
T	23679	4.3%
D	21504	3.9%
Other values (17)	164637	30.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	549609	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	68637	12.5%
N	44882	8.2%
R	41122	7.5%
A	39731	7.2%
O	39696	7.2%
L	39456	7.2%
I	33956	6.2%
S	32309	5.9%
T	23679	4.3%
D	21504	3.9%
Other values (17)	164637	30.0%

customer_id
Real number (ℝ)

High correlation

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	297.17848

Minimum	1
Maximum	599
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	148
median	296
Q3	446
95-th percentile	568
Maximum	599
Range	598
Interquartile range (IQR)	298

Descriptive statistics

Standard deviation	172.26314
Coefficient of variation (CV)	0.57966224
Kurtosis	-1.1884762
Mean	297.17848
Median Absolute Deviation (MAD)	149
Skewness	0.0088665271
Sum	26152598
Variance	29674.591
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
148	272	0.3%
526	251	0.3%
197	244	0.3%
144	239	0.3%
75	233	0.3%
236	233	0.3%
29	223	0.3%
257	221	0.3%
178	220	0.2%
410	216	0.2%
Other values (589)	85651	97.3%

Value	Count	Frequency (%)
1	156	0.2%
2	175	0.2%
3	144	0.2%
4	121	0.1%
5	183	0.2%
6	171	0.2%
7	191	0.2%
8	152	0.2%
9	129	0.1%
10	123	0.1%

Value	Count	Frequency (%)
599	102	0.1%
598	102	0.1%
597	144	0.2%
596	158	0.2%
595	141	0.2%
594	141	0.2%
593	129	0.1%
592	145	0.2%
591	120	0.1%
590	134	0.2%

cust_fn
Text

Distinct	591
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	11
Median length	10
Mean length	5.6736589
Min length	2

Characters and Unicode

Total characters	499299
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MARY
2nd row	MARY
3rd row	MARY
4th row	MARY
5th row	MARY

Value	Count	Frequency (%)
marion	388	0.4%
leslie	325	0.4%
tracy	303	0.3%
willie	291	0.3%
terry	291	0.3%
jessie	290	0.3%
jamie	277	0.3%
kelly	272	0.3%
eleanor	272	0.3%
karl	251	0.3%
Other values (581)	85043	96.6%

Most occurring characters

Value	Count	Frequency (%)
E	62900	12.6%
A	61300	12.3%
R	47061	9.4%
N	42781	8.6%
I	38757	7.8%
L	36735	7.4%
O	23432	4.7%
T	21523	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126309	25.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	499299	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	62900	12.6%
A	61300	12.3%
R	47061	9.4%
N	42781	8.6%
I	38757	7.8%
L	36735	7.4%
O	23432	4.7%
T	21523	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126309	25.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	499299	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	62900	12.6%
A	61300	12.3%
R	47061	9.4%
N	42781	8.6%
I	38757	7.8%
L	36735	7.4%
O	23432	4.7%
T	21523	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126309	25.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	499299	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	62900	12.6%
A	61300	12.3%
R	47061	9.4%
N	42781	8.6%
I	38757	7.8%
L	36735	7.4%
O	23432	4.7%
T	21523	4.3%
S	19614	3.9%
D	18887	3.8%
Other values (16)	126309	25.3%

cust_ln
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	12
Median length	10
Mean length	6.1921753
Min length	2

Characters and Unicode

Total characters	544930
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SMITH
2nd row	SMITH
3rd row	SMITH
4th row	SMITH
5th row	SMITH

Value	Count	Frequency (%)
hunt	272	0.3%
seal	251	0.3%
peters	244	0.3%
shaw	239	0.3%
sanders	233	0.3%
dean	233	0.3%
hernandez	223	0.3%
douglas	221	0.3%
snyder	220	0.2%
irby	216	0.2%
Other values (589)	85651	97.3%

Most occurring characters

Value	Count	Frequency (%)
E	58281	10.7%
R	54396	10.0%
A	47366	8.7%
N	43550	8.0%
O	38964	7.2%
L	38581	7.1%
S	35961	6.6%
I	26872	4.9%
T	26024	4.8%
H	20092	3.7%
Other values (16)	154843	28.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	544930	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	58281	10.7%
R	54396	10.0%
A	47366	8.7%
N	43550	8.0%
O	38964	7.2%
L	38581	7.1%
S	35961	6.6%
I	26872	4.9%
T	26024	4.8%
H	20092	3.7%
Other values (16)	154843	28.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	544930	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	58281	10.7%
R	54396	10.0%
A	47366	8.7%
N	43550	8.0%
O	38964	7.2%
L	38581	7.1%
S	35961	6.6%
I	26872	4.9%
T	26024	4.8%
H	20092	3.7%
Other values (16)	154843	28.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	544930	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	58281	10.7%
R	54396	10.0%
A	47366	8.7%
N	43550	8.0%
O	38964	7.2%
L	38581	7.1%
S	35961	6.6%
I	26872	4.9%
T	26024	4.8%
H	20092	3.7%
Other values (16)	154843	28.4%

email
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	40
Median length	38
Mean length	31.865834
Min length	26

Characters and Unicode

Total characters	2804289
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MARY.SMITH@sakilacustomer.org
2nd row	MARY.SMITH@sakilacustomer.org
3rd row	MARY.SMITH@sakilacustomer.org
4th row	MARY.SMITH@sakilacustomer.org
5th row	MARY.SMITH@sakilacustomer.org

Value	Count	Frequency (%)
eleanor.hunt@sakilacustomer.org	272	0.3%
karl.seal@sakilacustomer.org	251	0.3%
sue.peters@sakilacustomer.org	244	0.3%
clara.shaw@sakilacustomer.org	239	0.3%
tammy.sanders@sakilacustomer.org	233	0.3%
marcia.dean@sakilacustomer.org	233	0.3%
angela.hernandez@sakilacustomer.org	223	0.3%
marsha.douglas@sakilacustomer.org	221	0.3%
marion.snyder@sakilacustomer.org	220	0.2%
curtis.irby@sakilacustomer.org	216	0.2%
Other values (589)	85651	97.3%

Most occurring characters

Value	Count	Frequency (%)
r	176006	6.3%
.	176006	6.3%
o	176006	6.3%
s	176006	6.3%
a	176006	6.3%
E	121181	4.3%
A	108666	3.9%
R	101457	3.6%
l	88003	3.1%
g	88003	3.1%
Other values (31)	1416949	50.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2804289	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	176006	6.3%
.	176006	6.3%
o	176006	6.3%
s	176006	6.3%
a	176006	6.3%
E	121181	4.3%
A	108666	3.9%
R	101457	3.6%
l	88003	3.1%
g	88003	3.1%
Other values (31)	1416949	50.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2804289	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	176006	6.3%
.	176006	6.3%
o	176006	6.3%
s	176006	6.3%
a	176006	6.3%
E	121181	4.3%
A	108666	3.9%
R	101457	3.6%
l	88003	3.1%
g	88003	3.1%
Other values (31)	1416949	50.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2804289	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	176006	6.3%
.	176006	6.3%
o	176006	6.3%
s	176006	6.3%
a	176006	6.3%
E	121181	4.3%
A	108666	3.9%
R	101457	3.6%
l	88003	3.1%
g	88003	3.1%
Other values (31)	1416949	50.5%

active
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

1	85737
0	2266

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	88003
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	85737	97.4%
0	2266	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	85737	97.4%
0	2266	2.6%

Most occurring characters

Value	Count	Frequency (%)
1	85737	97.4%
0	2266	2.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	85737	97.4%
0	2266	2.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	85737	97.4%
0	2266	2.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	85737	97.4%
0	2266	2.6%

rental_id
Real number (ℝ)

Distinct	16004
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8032.5002

Minimum	1
Maximum	16049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	816.1
Q1	4026.5
median	8039
Q3	12027
95-th percentile	15247
Maximum	16049
Range	16048
Interquartile range (IQR)	8000.5

Descriptive statistics

Standard deviation	4631.7329
Coefficient of variation (CV)	0.57662407
Kurtosis	-1.2006239
Mean	8032.5002
Median Absolute Deviation (MAD)	4002
Skewness	-0.0011786957
Sum	7.0688411 × 10⁸
Variance	21452950
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	20	< 0.1%
14200	15	< 0.1%
4845	15	< 0.1%
7446	15	< 0.1%
8014	15	< 0.1%
12701	15	< 0.1%
7152	15	< 0.1%
5930	15	< 0.1%
15187	15	< 0.1%
2796	15	< 0.1%
Other values (15994)	87848	99.8%

Value	Count	Frequency (%)
1	20	< 0.1%
2	5	< 0.1%
3	2	< 0.1%
4	4	< 0.1%
5	8	< 0.1%
6	4	< 0.1%
7	6	< 0.1%
8	4	< 0.1%
9	3	< 0.1%
10	7	< 0.1%

Value	Count	Frequency (%)
16049	6	< 0.1%
16048	2	< 0.1%
16047	7	< 0.1%
16046	5	< 0.1%
16045	5	< 0.1%
16044	5	< 0.1%
16043	7	< 0.1%
16042	3	< 0.1%
16041	6	< 0.1%
16040	8	< 0.1%

rental_date
Date

Distinct	15776
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Minimum	2005-05-24 22:53:30
Maximum	2006-02-14 15:16:03
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

return_date
Date

Distinct	15796
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Minimum	2005-05-25 23:55:21
Maximum	2005-09-02 02:35:22
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

payment_id
Real number (ℝ)

High correlation

Distinct	16009
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8026.4141

Minimum	1
Maximum	16049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	795.1
Q1	4037.5
median	8034
Q3	12029
95-th percentile	15218
Maximum	16049
Range	16048
Interquartile range (IQR)	7991.5

Descriptive statistics

Standard deviation	4627.9028
Coefficient of variation (CV)	0.57658411
Kurtosis	-1.1977652
Mean	8026.4141
Median Absolute Deviation (MAD)	3996
Skewness	-0.0065076363
Sum	7.0634852 × 10⁸
Variance	21417485
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13129	15	< 0.1%
5662	15	< 0.1%
12463	15	< 0.1%
2280	15	< 0.1%
6853	15	< 0.1%
10004	15	< 0.1%
13202	15	< 0.1%
14839	15	< 0.1%
9457	15	< 0.1%
288	15	< 0.1%
Other values (15999)	87853	99.8%

Value	Count	Frequency (%)
1	4	< 0.1%
2	5	< 0.1%
3	1	< 0.1%
4	3	< 0.1%
5	1	< 0.1%
6	6	< 0.1%
7	4	< 0.1%
8	6	< 0.1%
9	5	< 0.1%
10	5	< 0.1%

Value	Count	Frequency (%)
16049	4	< 0.1%
16048	8	< 0.1%
16047	5	< 0.1%
16046	4	< 0.1%
16045	3	< 0.1%
16044	5	< 0.1%
16043	3	< 0.1%
16042	5	< 0.1%
16041	9	< 0.1%
16040	6	< 0.1%

amount
Real number (ℝ)

High correlation

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1771512

Minimum	0
Maximum	11.99
Zeros	133
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0.99
Q1	2.99
median	3.99
Q3	4.99
95-th percentile	8.99
Maximum	11.99
Range	11.99
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.3456479
Coefficient of variation (CV)	0.56154248
Kurtosis	-0.24037839
Mean	4.1771512
Median Absolute Deviation (MAD)	1
Skewness	0.46837152
Sum	367601.84
Variance	5.502064
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
4.99	20434	23.2%
2.99	19873	22.6%
0.99	16275	18.5%
5.99	7181	8.2%
3.99	6354	7.2%
6.99	5929	6.7%
7.99	3654	4.2%
1.99	3498	4.0%
8.99	2633	3.0%
9.99	1302	1.5%
Other values (9)	870	1.0%

Value	Count	Frequency (%)
0	133	0.2%
0.99	16275	18.5%
1.98	4	< 0.1%
1.99	3498	4.0%
2.99	19873	22.6%
3.98	43	< 0.1%
3.99	6354	7.2%
4.99	20434	23.2%
5.98	47	0.1%
5.99	7181	8.2%

Value	Count	Frequency (%)
11.99	49	0.1%
10.99	549	0.6%
9.99	1302	1.5%
9.98	6	< 0.1%
8.99	2633	3.0%
8.97	7	< 0.1%
7.99	3654	4.2%
7.98	32	< 0.1%
6.99	5929	6.7%
5.99	7181	8.2%

payment_date
Date

Distinct	15780
Distinct (%)	17.9%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Minimum	2005-05-24 22:53:30
Maximum	2006-02-14 15:16:03
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

inventory_id
Real number (ℝ)

High correlation

Distinct	4567
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2296.0328

Minimum	1
Maximum	4581
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	214
Q1	1158
median	2287
Q3	3428
95-th percentile	4367
Maximum	4581
Range	4580
Interquartile range (IQR)	2270

Descriptive statistics

Standard deviation	1321.4595
Coefficient of variation (CV)	0.57554035
Kurtosis	-1.1822263
Mean	2296.0328
Median Absolute Deviation (MAD)	1134
Skewness	-0.0059873723
Sum	2.0205778 × 10⁸
Variance	1746255.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1122	65	0.1%
1123	65	0.1%
2423	60	0.1%
1899	60	0.1%
158	60	0.1%
2337	60	0.1%
4095	60	0.1%
2371	60	0.1%
2424	60	0.1%
3328	55	0.1%
Other values (4557)	87398	99.3%

Value	Count	Frequency (%)
1	30	< 0.1%
2	50	0.1%
3	20	< 0.1%
4	20	< 0.1%
6	50	0.1%
7	40	< 0.1%
8	20	< 0.1%
9	8	< 0.1%
10	12	< 0.1%
11	8	< 0.1%

Value	Count	Frequency (%)
4581	15	< 0.1%
4580	6	< 0.1%
4579	15	< 0.1%
4578	9	< 0.1%
4577	15	< 0.1%
4576	12	< 0.1%
4575	12	< 0.1%
4574	9	< 0.1%
4573	25	< 0.1%
4572	20	< 0.1%

store_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

1	47969
2	40034

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	88003
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

staff_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

1	47969
2	40034

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	88003
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88003	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	47969	54.5%
2	40034	45.5%

staff_fn
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Mike	47969
Jon	40034

Length

Max length	4
Median length	4
Mean length	3.5450837
Min length	3

Characters and Unicode

Total characters	311978
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mike
2nd row	Mike
3rd row	Mike
4th row	Mike
5th row	Mike

Common Values

Value	Count	Frequency (%)
Mike	47969	54.5%
Jon	40034	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mike	47969	54.5%
jon	40034	45.5%

Most occurring characters

Value	Count	Frequency (%)
M	47969	15.4%
i	47969	15.4%
k	47969	15.4%
e	47969	15.4%
J	40034	12.8%
o	40034	12.8%
n	40034	12.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	311978	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
M	47969	15.4%
i	47969	15.4%
k	47969	15.4%
e	47969	15.4%
J	40034	12.8%
o	40034	12.8%
n	40034	12.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	311978	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
M	47969	15.4%
i	47969	15.4%
k	47969	15.4%
e	47969	15.4%
J	40034	12.8%
o	40034	12.8%
n	40034	12.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	311978	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
M	47969	15.4%
i	47969	15.4%
k	47969	15.4%
e	47969	15.4%
J	40034	12.8%
o	40034	12.8%
n	40034	12.8%

staff_ln
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Hillyer	47969
Stephens	40034

Length

Max length	8
Median length	7
Mean length	7.4549163
Min length	7

Characters and Unicode

Total characters	656055
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hillyer
2nd row	Hillyer
3rd row	Hillyer
4th row	Hillyer
5th row	Hillyer

Common Values

Value	Count	Frequency (%)
Hillyer	47969	54.5%
Stephens	40034	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hillyer	47969	54.5%
stephens	40034	45.5%

Most occurring characters

Value	Count	Frequency (%)
e	128037	19.5%
l	95938	14.6%
H	47969	7.3%
i	47969	7.3%
y	47969	7.3%
r	47969	7.3%
S	40034	6.1%
t	40034	6.1%
p	40034	6.1%
h	40034	6.1%
Other values (2)	80068	12.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	656055	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	128037	19.5%
l	95938	14.6%
H	47969	7.3%
i	47969	7.3%
y	47969	7.3%
r	47969	7.3%
S	40034	6.1%
t	40034	6.1%
p	40034	6.1%
h	40034	6.1%
Other values (2)	80068	12.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	656055	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	128037	19.5%
l	95938	14.6%
H	47969	7.3%
i	47969	7.3%
y	47969	7.3%
r	47969	7.3%
S	40034	6.1%
t	40034	6.1%
p	40034	6.1%
h	40034	6.1%
Other values (2)	80068	12.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	656055	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	128037	19.5%
l	95938	14.6%
H	47969	7.3%
i	47969	7.3%
y	47969	7.3%
r	47969	7.3%
S	40034	6.1%
t	40034	6.1%
p	40034	6.1%
h	40034	6.1%
Other values (2)	80068	12.2%

address_id
Real number (ℝ)

High correlation

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	301.89364

Minimum	5
Maximum	605
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	5
5-th percentile	33
Q1	152
median	301
Q3	451
95-th percentile	574
Maximum	605
Range	600
Interquartile range (IQR)	299

Descriptive statistics

Standard deviation	172.89386
Coefficient of variation (CV)	0.57269791
Kurtosis	-1.188725
Mean	301.89364
Median Absolute Deviation (MAD)	149
Skewness	0.010566113
Sum	26567546
Variance	29892.286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
152	272	0.3%
532	251	0.3%
201	244	0.3%
148	239	0.3%
79	233	0.3%
240	233	0.3%
33	223	0.3%
262	221	0.3%
182	220	0.2%
415	216	0.2%
Other values (589)	85651	97.3%

Value	Count	Frequency (%)
5	156	0.2%
6	175	0.2%
7	144	0.2%
8	121	0.1%
9	183	0.2%
10	171	0.2%
11	191	0.2%
12	152	0.2%
13	129	0.1%
14	123	0.1%

Value	Count	Frequency (%)
605	102	0.1%
604	102	0.1%
603	144	0.2%
602	158	0.2%
601	141	0.2%
600	141	0.2%
599	129	0.1%
598	145	0.2%
597	120	0.1%
596	134	0.2%

address
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	38
Median length	34
Mean length	19.461007
Min length	9

Characters and Unicode

Total characters	1712627
Distinct characters	66
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1913 Hanoi Way
2nd row	1913 Hanoi Way
3rd row	1913 Hanoi Way
4th row	1913 Hanoi Way
5th row	1913 Hanoi Way

Value	Count	Frequency (%)
parkway	11137	3.9%
manor	9908	3.4%
avenue	8963	3.1%
way	8854	3.1%
lane	8768	3.0%
street	8622	3.0%
place	8225	2.8%
loop	8071	2.8%
boulevard	7812	2.7%
drive	7643	2.6%
Other values (957)	201269	69.6%

Most occurring characters

Value	Count	Frequency (%)
	201269	11.8%
a	179026	10.5%
e	110215	6.4%
o	87025	5.1%
r	83511	4.9%
n	82203	4.8%
1	67763	4.0%
i	51598	3.0%
l	51231	3.0%
u	49057	2.9%
Other values (56)	749729	43.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1712627	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	201269	11.8%
a	179026	10.5%
e	110215	6.4%
o	87025	5.1%
r	83511	4.9%
n	82203	4.8%
1	67763	4.0%
i	51598	3.0%
l	51231	3.0%
u	49057	2.9%
Other values (56)	749729	43.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1712627	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	201269	11.8%
a	179026	10.5%
e	110215	6.4%
o	87025	5.1%
r	83511	4.9%
n	82203	4.8%
1	67763	4.0%
i	51598	3.0%
l	51231	3.0%
u	49057	2.9%
Other values (56)	749729	43.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1712627	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	201269	11.8%
a	179026	10.5%
e	110215	6.4%
o	87025	5.1%
r	83511	4.9%
n	82203	4.8%
1	67763	4.0%
i	51598	3.0%
l	51231	3.0%
u	49057	2.9%
Other values (56)	749729	43.8%

postal_code
Real number (ℝ)

Distinct	596
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50338.395

Minimum	3
Maximum	99865
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	3
5-th percentile	4855
Q1	25220
median	50805
Q3	74750
95-th percentile	95509
Maximum	99865
Range	99862
Interquartile range (IQR)	49530

Descriptive statistics

Standard deviation	28837.245
Coefficient of variation (CV)	0.5728678
Kurtosis	-1.1638411
Mean	50338.395
Median Absolute Deviation (MAD)	24669
Skewness	-0.019266617
Sum	4.4299297 × 10⁹
Variance	8.3158673 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52137	299	0.3%
9668	284	0.3%
92150	272	0.3%
22474	270	0.3%
31342	251	0.3%
89459	244	0.3%
30861	239	0.3%
72394	233	0.3%
18727	233	0.3%
65750	223	0.3%
Other values (586)	85455	97.1%

Value	Count	Frequency (%)
3	122	0.1%
400	138	0.2%
504	130	0.1%
841	108	0.1%
943	133	0.2%
966	118	0.1%
1027	132	0.1%
1079	122	0.1%
1195	146	0.2%
1545	190	0.2%

Value	Count	Frequency (%)
99865	126	0.1%
99780	165	0.2%
99552	156	0.2%
99457	168	0.2%
99405	178	0.2%
99124	124	0.1%
98889	141	0.2%
98883	164	0.2%
98775	121	0.1%
98573	157	0.2%

city_id
Real number (ℝ)

Distinct	597
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	301.38698

Minimum	1
Maximum	600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	31
Q1	148
median	304
Q3	452
95-th percentile	569
Maximum	600
Range	599
Interquartile range (IQR)	304

Descriptive statistics

Standard deviation	173.50356
Coefficient of variation (CV)	0.57568368
Kurtosis	-1.2104514
Mean	301.38698
Median Absolute Deviation (MAD)	152
Skewness	-0.016064084
Sum	26522958
Variance	30103.486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	275	0.3%
442	272	0.3%
312	271	0.3%
101	251	0.3%
109	244	0.3%
340	239	0.3%
108	233	0.3%
527	233	0.3%
474	223	0.3%
64	221	0.3%
Other values (587)	85541	97.2%

Value	Count	Frequency (%)
1	156	0.2%
2	124	0.1%
3	177	0.2%
4	160	0.2%
5	131	0.1%
6	123	0.1%
7	178	0.2%
8	136	0.2%
9	164	0.2%
10	157	0.2%

Value	Count	Frequency (%)
600	131	0.1%
599	171	0.2%
598	157	0.2%
597	138	0.2%
596	153	0.2%
595	81	0.1%
594	123	0.1%
593	144	0.2%
592	139	0.2%
591	137	0.2%

city
Text

Distinct	597
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	26
Median length	21
Mean length	8.3923616
Min length	2

Characters and Unicode

Total characters	738553
Distinct characters	57
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sasebo
2nd row	Sasebo
3rd row	Sasebo
4th row	Sasebo
5th row	Sasebo

Value	Count	Frequency (%)
de	1936	1.8%
san	946	0.9%
la	727	0.7%
del	581	0.5%
santa	578	0.5%
el	433	0.4%
hill	411	0.4%
santiago	395	0.4%
plata	353	0.3%
felipe	344	0.3%
Other values (673)	100711	93.8%

Most occurring characters

Value	Count	Frequency (%)
a	109633	14.8%
n	52078	7.1%
o	47635	6.4%
i	46556	6.3%
e	42704	5.8%
r	38393	5.2%
u	34239	4.6%
l	30362	4.1%
s	24885	3.4%
t	24653	3.3%
Other values (47)	287415	38.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	738553	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	109633	14.8%
n	52078	7.1%
o	47635	6.4%
i	46556	6.3%
e	42704	5.8%
r	38393	5.2%
u	34239	4.6%
l	30362	4.1%
s	24885	3.4%
t	24653	3.3%
Other values (47)	287415	38.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	738553	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	109633	14.8%
n	52078	7.1%
o	47635	6.4%
i	46556	6.3%
e	42704	5.8%
r	38393	5.2%
u	34239	4.6%
l	30362	4.1%
s	24885	3.4%
t	24653	3.3%
Other values (47)	287415	38.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	738553	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	109633	14.8%
n	52078	7.1%
o	47635	6.4%
i	46556	6.3%
e	42704	5.8%
r	38393	5.2%
u	34239	4.6%
l	30362	4.1%
s	24885	3.4%
t	24653	3.3%
Other values (47)	287415	38.9%

country_id
Real number (ℝ)

Distinct	108
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.85813

Minimum	1
Maximum	109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	687.7 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	29
median	50
Q3	80
95-th percentile	103
Maximum	109
Range	108
Interquartile range (IQR)	51

Descriptive statistics

Standard deviation	30.066213
Coefficient of variation (CV)	0.52879356
Kurtosis	-1.160329
Mean	56.85813
Median Absolute Deviation (MAD)	27
Skewness	0.056191588
Sum	5003686
Variance	903.97716
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	8637	9.8%
23	7724	8.8%
103	5428	6.2%
50	4565	5.2%
60	4493	5.1%
15	4058	4.6%
80	3895	4.4%
75	3160	3.6%
97	2094	2.4%
45	2014	2.3%
Other values (98)	41935	47.7%

Value	Count	Frequency (%)
1	109	0.1%
2	457	0.5%
3	111	0.1%
4	301	0.3%
5	195	0.2%
6	1884	2.1%
7	150	0.2%
9	403	0.5%
10	302	0.3%
11	134	0.2%

Value	Count	Frequency (%)
109	174	0.2%
108	328	0.4%
107	628	0.7%
106	190	0.2%
105	908	1.0%
104	963	1.1%
103	5428	6.2%
102	1210	1.4%
101	476	0.5%
100	823	0.9%

country
Text

Distinct	108
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Length

Max length	37
Median length	29
Mean length	8.1360181
Min length	4

Characters and Unicode

Total characters	715994
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Japan
2nd row	Japan
3rd row	Japan
4th row	Japan
5th row	Japan

Value	Count	Frequency (%)
india	8637	8.0%
china	7724	7.2%
united	7114	6.6%
states	5428	5.0%
japan	4565	4.2%
mexico	4493	4.2%
brazil	4058	3.8%
russian	3895	3.6%
federation	3895	3.6%
philippines	3160	2.9%
Other values (122)	54825	50.9%

Most occurring characters

Value	Count	Frequency (%)
a	95658	13.4%
i	80550	11.3%
n	72678	10.2%
e	58230	8.1%
t	35504	5.0%
r	31054	4.3%
d	30203	4.2%
o	26432	3.7%
s	25093	3.5%
l	20016	2.8%
Other values (44)	240576	33.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	715994	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	95658	13.4%
i	80550	11.3%
n	72678	10.2%
e	58230	8.1%
t	35504	5.0%
r	31054	4.3%
d	30203	4.2%
o	26432	3.7%
s	25093	3.5%
l	20016	2.8%
Other values (44)	240576	33.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	715994	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	95658	13.4%
i	80550	11.3%
n	72678	10.2%
e	58230	8.1%
t	35504	5.0%
r	31054	4.3%
d	30203	4.2%
o	26432	3.7%
s	25093	3.5%
l	20016	2.8%
Other values (44)	240576	33.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	715994	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	95658	13.4%
i	80550	11.3%
n	72678	10.2%
e	58230	8.1%
t	35504	5.0%
r	31054	4.3%
d	30203	4.2%
o	26432	3.7%
s	25093	3.5%
l	20016	2.8%
Other values (44)	240576	33.6%

category
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	687.7 KiB

Sports	6936
Animation	6600
Action	6307
Documentary	6188
Drama	5929
Other values (11)	56043

Length

Max length	11
Median length	9
Mean length	6.5330955
Min length	3

Characters and Unicode

Total characters	574932
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Classics
2nd row	Classics
3rd row	Classics
4th row	Classics
5th row	Sports

Common Values

Value	Count	Frequency (%)
Sports	6936	7.9%
Animation	6600	7.5%
Action	6307	7.2%
Documentary	6188	7.0%
Drama	5929	6.7%
Sci-Fi	5743	6.5%
Family	5631	6.4%
Foreign	5559	6.3%
Children	5510	6.3%
New	5199	5.9%
Other values (6)	28401	32.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sports	6936	7.9%
animation	6600	7.5%
action	6307	7.2%
documentary	6188	7.0%
drama	5929	6.7%
sci-fi	5743	6.5%
family	5631	6.4%
foreign	5559	6.3%
children	5510	6.3%
new	5199	5.9%
Other values (6)	28401	32.3%

Most occurring characters

Value	Count	Frequency (%)
i	57284	10.0%
r	49574	8.6%
o	46108	8.0%
a	44585	7.8%
n	36764	6.4%
e	36338	6.3%
m	33562	5.8%
s	31255	5.4%
c	27829	4.8%
t	26031	4.5%
Other values (20)	185602	32.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	574932	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	57284	10.0%
r	49574	8.6%
o	46108	8.0%
a	44585	7.8%
n	36764	6.4%
e	36338	6.3%
m	33562	5.8%
s	31255	5.4%
c	27829	4.8%
t	26031	4.5%
Other values (20)	185602	32.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	574932	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	57284	10.0%
r	49574	8.6%
o	46108	8.0%
a	44585	7.8%
n	36764	6.4%
e	36338	6.3%
m	33562	5.8%
s	31255	5.4%
c	27829	4.8%
t	26031	4.5%
Other values (20)	185602	32.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	574932	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	57284	10.0%
r	49574	8.6%
o	46108	8.0%
a	44585	7.8%
n	36764	6.4%
e	36338	6.3%
m	33562	5.8%
s	31255	5.4%
c	27829	4.8%
t	26031	4.5%
Other values (20)	185602	32.3%

Interactions

Correlations

	active	actor_id	address_id	amount	category	city_id	country_id	customer_id	film_id	inventory_id	length	payment_id	postal_code	rating	rental_duration	rental_id	rental_rate	replacement_cost	staff_fn	staff_id	staff_ln	store_id
active	1.000	0.000	0.085	0.027	0.032	0.109	0.094	0.092	0.023	0.021	0.029	0.092	0.138	0.014	0.012	0.021	0.007	0.018	0.003	0.003	0.003	0.003
actor_id	0.000	1.000	0.001	-0.007	0.056	0.002	0.001	0.001	0.015	0.015	0.015	0.001	0.004	0.043	0.041	-0.004	0.043	-0.001	0.000	0.000	0.000	0.000
address_id	0.085	0.001	1.000	0.014	0.032	0.042	-0.042	1.000	-0.003	-0.003	-0.014	1.000	-0.043	0.019	0.028	-0.003	0.027	-0.022	0.076	0.076	0.076	0.076
amount	0.027	-0.007	0.014	1.000	0.065	0.001	0.013	0.014	0.027	0.027	0.003	0.014	-0.013	0.034	0.171	0.002	0.705	-0.030	0.016	0.016	0.016	0.016
category	0.032	0.056	0.032	0.065	1.000	0.033	0.029	0.032	0.139	0.138	0.149	0.031	0.029	0.155	0.161	0.024	0.145	0.141	0.030	0.030	0.030	0.030
city_id	0.109	0.002	0.042	0.001	0.033	1.000	-0.059	0.042	0.009	0.009	-0.002	0.042	-0.071	0.020	0.021	-0.005	0.026	-0.001	0.104	0.104	0.104	0.104
country_id	0.094	0.001	-0.042	0.013	0.029	-0.059	1.000	-0.042	0.017	0.017	0.012	-0.042	0.001	0.024	0.021	-0.005	0.020	0.004	0.102	0.102	0.102	0.102
customer_id	0.092	0.001	1.000	0.014	0.032	0.042	-0.042	1.000	-0.003	-0.003	-0.014	1.000	-0.043	0.018	0.028	-0.003	0.027	-0.022	0.074	0.074	0.074	0.074
film_id	0.023	0.015	-0.003	0.027	0.139	0.009	0.017	-0.003	1.000	1.000	0.053	-0.003	-0.010	0.120	0.112	-0.001	0.112	-0.040	0.034	0.034	0.034	0.034
inventory_id	0.021	0.015	-0.003	0.027	0.138	0.009	0.017	-0.003	1.000	1.000	0.053	-0.003	-0.010	0.119	0.112	-0.001	0.116	-0.040	0.033	0.033	0.033	0.033
length	0.029	0.015	-0.014	0.003	0.149	-0.002	0.012	-0.014	0.053	0.053	1.000	-0.014	-0.004	0.101	0.087	0.001	0.104	0.014	0.016	0.016	0.016	0.016
payment_id	0.092	0.001	1.000	0.014	0.031	0.042	-0.042	1.000	-0.003	-0.003	-0.014	1.000	-0.043	0.017	0.028	-0.002	0.025	-0.022	0.072	0.072	0.072	0.072
postal_code	0.138	0.004	-0.043	-0.013	0.029	-0.071	0.001	-0.043	-0.010	-0.010	-0.004	-0.043	1.000	0.017	0.015	0.006	0.026	-0.001	0.090	0.090	0.090	0.090
rating	0.014	0.043	0.019	0.034	0.155	0.020	0.024	0.018	0.120	0.119	0.101	0.017	0.017	1.000	0.096	0.020	0.038	0.111	0.015	0.015	0.015	0.015
rental_duration	0.012	0.041	0.028	0.171	0.161	0.021	0.021	0.028	0.112	0.112	0.087	0.028	0.015	0.096	1.000	0.021	0.072	0.083	0.007	0.007	0.007	0.007
rental_id	0.021	-0.004	-0.003	0.002	0.024	-0.005	-0.005	-0.003	-0.001	-0.001	0.001	-0.002	0.006	0.020	0.021	1.000	0.024	0.004	0.028	0.028	0.028	0.028
rental_rate	0.007	0.043	0.027	0.705	0.145	0.026	0.020	0.027	0.112	0.116	0.104	0.025	0.026	0.038	0.072	0.024	1.000	0.109	0.000	0.000	0.000	0.000
replacement_cost	0.018	-0.001	-0.022	-0.030	0.141	-0.001	0.004	-0.022	-0.040	-0.040	0.014	-0.022	-0.001	0.111	0.083	0.004	0.109	1.000	0.027	0.027	0.027	0.027
staff_fn	0.003	0.000	0.076	0.016	0.030	0.104	0.102	0.074	0.034	0.033	0.016	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
staff_id	0.003	0.000	0.076	0.016	0.030	0.104	0.102	0.074	0.034	0.033	0.016	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
staff_ln	0.003	0.000	0.076	0.016	0.030	0.104	0.102	0.074	0.034	0.033	0.016	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000
store_id	0.003	0.000	0.076	0.016	0.030	0.104	0.102	0.074	0.034	0.033	0.016	0.072	0.090	0.015	0.007	0.028	0.000	0.027	1.000	1.000	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	film_id	title	description	rental_duration	rental_rate	length	replacement_cost	rating	actor_id	actor_fn	actor_ln	customer_id	cust_fn	cust_ln	email	active	rental_id	rental_date	return_date	payment_id	amount	payment_date	inventory_id	store_id	staff_id	staff_fn	staff_ln	address_id	address	postal_code	city_id	city	country_id	country	category
0	663	PATIENT SISTER	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia	7	0.99	99	29.99	NC-17	90	SEAN	GUINESS	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	76	2005-05-25 11:30:37	2005-06-03 12:00:37	1	2.99	2005-05-25 11:30:37	3021	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Classics
1	663	PATIENT SISTER	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia	7	0.99	99	29.99	NC-17	74	MILLA	KEITEL	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	76	2005-05-25 11:30:37	2005-06-03 12:00:37	1	2.99	2005-05-25 11:30:37	3021	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Classics
2	663	PATIENT SISTER	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia	7	0.99	99	29.99	NC-17	37	VAL	BOLGER	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	76	2005-05-25 11:30:37	2005-06-03 12:00:37	1	2.99	2005-05-25 11:30:37	3021	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Classics
3	663	PATIENT SISTER	A Emotional Epistle of a Squirrel And a Robot who must Confront a Lumberjack in Soviet Georgia	7	0.99	99	29.99	NC-17	20	LUCILLE	TRACY	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	76	2005-05-25 11:30:37	2005-06-03 12:00:37	1	2.99	2005-05-25 11:30:37	3021	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Classics
4	875	TALENTED HOMICIDE	A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat	6	0.99	173	9.99	PG	142	JADA	RYDER	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	573	2005-05-28 10:35:23	2005-06-03 06:32:23	2	0.99	2005-05-28 10:35:23	4020	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Sports
5	875	TALENTED HOMICIDE	A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat	6	0.99	173	9.99	PG	131	JANE	JACKMAN	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	573	2005-05-28 10:35:23	2005-06-03 06:32:23	2	0.99	2005-05-28 10:35:23	4020	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Sports
6	875	TALENTED HOMICIDE	A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat	6	0.99	173	9.99	PG	85	MINNIE	ZELLWEGER	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	573	2005-05-28 10:35:23	2005-06-03 06:32:23	2	0.99	2005-05-28 10:35:23	4020	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Sports
7	875	TALENTED HOMICIDE	A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat	6	0.99	173	9.99	PG	44	NICK	STALLONE	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	573	2005-05-28 10:35:23	2005-06-03 06:32:23	2	0.99	2005-05-28 10:35:23	4020	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Sports
8	875	TALENTED HOMICIDE	A Lacklusture Panorama of a Dentist And a Forensic Psychologist who must Outrace a Pioneer in A U-Boat	6	0.99	173	9.99	PG	36	BURT	DUKAKIS	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	573	2005-05-28 10:35:23	2005-06-03 06:32:23	2	0.99	2005-05-28 10:35:23	4020	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Sports
9	611	MUSKETEERS WAIT	A Touching Yarn of a Student And a Moose who must Fight a Mad Cow in Australia	7	4.99	73	17.99	PG	152	BEN	HARRIS	1	MARY	SMITH	MARY.SMITH@sakilacustomer.org	1	1185	2005-06-15 00:54:12	2005-06-23 02:42:12	3	5.99	2005-06-15 00:54:12	2785	1	1	Mike	Hillyer	5	1913 Hanoi Way	35200	463	Sasebo	50	Japan	Classics

	film_id	title	description	rental_duration	rental_rate	length	replacement_cost	rating	actor_id	actor_fn	actor_ln	customer_id	cust_fn	cust_ln	email	active	rental_id	rental_date	return_date	payment_id	amount	payment_date	inventory_id	store_id	staff_id	staff_fn	staff_ln	address_id	address	postal_code	city_id	city	country_id	country	category
87993	869	SUSPECTS QUILLS	A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse	4	2.99	47	22.99	PG	158	VIVIEN	BASINGER	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15719	2005-08-23 11:08:46	2005-08-25 07:25:46	16048	2.99	2005-08-23 11:08:46	3990	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Action
87994	869	SUSPECTS QUILLS	A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse	4	2.99	47	22.99	PG	130	GRETA	KEITEL	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15719	2005-08-23 11:08:46	2005-08-25 07:25:46	16048	2.99	2005-08-23 11:08:46	3990	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Action
87995	869	SUSPECTS QUILLS	A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse	4	2.99	47	22.99	PG	112	RUSSELL	BACALL	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15719	2005-08-23 11:08:46	2005-08-25 07:25:46	16048	2.99	2005-08-23 11:08:46	3990	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Action
87996	869	SUSPECTS QUILLS	A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse	4	2.99	47	22.99	PG	85	MINNIE	ZELLWEGER	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15719	2005-08-23 11:08:46	2005-08-25 07:25:46	16048	2.99	2005-08-23 11:08:46	3990	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Action
87997	869	SUSPECTS QUILLS	A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse	4	2.99	47	22.99	PG	70	MICHELLE	MCCONAUGHEY	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15719	2005-08-23 11:08:46	2005-08-25 07:25:46	16048	2.99	2005-08-23 11:08:46	3990	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Action
87998	869	SUSPECTS QUILLS	A Emotional Epistle of a Pioneer And a Crocodile who must Battle a Man in A Manhattan Penthouse	4	2.99	47	22.99	PG	40	JOHNNY	CAGE	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15719	2005-08-23 11:08:46	2005-08-25 07:25:46	16048	2.99	2005-08-23 11:08:46	3990	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Action
87999	83	BLUES INSTINCT	A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House	5	2.99	50	18.99	G	181	MATTHEW	CARREY	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15725	2005-08-23 11:25:00	2005-08-26 11:46:00	16049	2.99	2005-08-23 11:25:00	378	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Family
88000	83	BLUES INSTINCT	A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House	5	2.99	50	18.99	G	122	SALMA	NOLTE	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15725	2005-08-23 11:25:00	2005-08-26 11:46:00	16049	2.99	2005-08-23 11:25:00	378	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Family
88001	83	BLUES INSTINCT	A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House	5	2.99	50	18.99	G	106	GROUCHO	DUNST	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15725	2005-08-23 11:25:00	2005-08-26 11:46:00	16049	2.99	2005-08-23 11:25:00	378	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Family
88002	83	BLUES INSTINCT	A Insightful Documentary of a Boat And a Composer who must Meet a Forensic Psychologist in An Abandoned Fun House	5	2.99	50	18.99	G	24	CAMERON	STREEP	599	AUSTIN	CINTRON	AUSTIN.CINTRON@sakilacustomer.org	1	15725	2005-08-23 11:25:00	2005-08-26 11:46:00	16049	2.99	2005-08-23 11:25:00	378	2	2	Jon	Stephens	605	1325 Fukuyama Street	27107	537	Tieli	23	China	Family

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block